home *** CD-ROM | disk | FTP | other *** search
/ ShareWare OnLine 2 / ShareWare OnLine Volume 2 (CMS Software)(1993).iso / finance / rebel30.zip / COGO.RB2 < prev    next >
Text File  |  1993-01-22  |  13KB  |  1 lines

  1. ~~Sv2~~Sw11~~Sr1~~Sd4~~Sm{7,0,7,0}~~V{1,1}~~V{2,2}~~V{3,1}~~V{4,10}~~V{5,2}~~V{6,13}~~V{7,2}~~V{8,13}~~V{9,2}~~V{10,5}~~V{11,2}~~V{12,24}~~V{13,45}~~V{14,3}~~V{15,29}~~R2C5Q13D15;                Example Survey~~R4C3Q37;       NOTE:  All of the COGO functions used in this worksheet~~R5C3Q37;       have been entered in column 12.  Their formulas can be~~R6C3Q37;       displayed at the bottom of screen by running the Cell~~R7C3Q37;       Pointer slowly down that column.  Coordinate <01>, the~~R8C4Q33;      initial point, can be changed to any value you want with~~R9C4Q33;      the @NE function, which will cause every coordinate in the~~R10C4Q33;      worksheet to be recomputed.  For example, try entering~~R11C4Q33;      "@NE(500,600)" in cell [16,12] (without the quotes).~~R14C6Q25D14;        LEGAL DESCRIPTION  (as platted)~~R15C2Q41D15;----------------------------------------------------------------------------~~R16C3Q21D14;Beginning at the SE Corner of Lot 1~~R16C9Q1D15; |~~R16C10Q1D14;<01>~~R16C11Q1D15;|~~R16C12D14F9248E2{1e+00|1e+03|1e+03};@NE(1000,1000)~~R16C13Q5D14;   Try setting this coordinate to:  @NE(500,500)~~R17C3Q5D7;    thence~~R17C6D7F800E0{3.65153e+02};365.1530~~R17C8D7E0{2.4187e+02};241.87~~R17C9Q1D15; |~~R17C11Q1D15;|~~R17C12D7M3{16,12|17,6|17,8}F9248A6E2{2.047416666664888e+02|7.803326850209477e+02|8.987707175275167e+02};@Traverse(~1,3,1,~2,~3,1)~~R17C13Q1;   SW corner~~R18C3Q5D7;    thence~~R18C6D7F800E0{4.001e+02};400.1000~~R18C8D7E0{1.0076e+02};100.76~~R18C9Q1D15; |~~R18C11Q1D15;|~~R18C12D7M3{17,12|18,6|18,8}F9248A6E2{9.016666666684449e+01|7.800395864749202e+02|9.995302912326606e+02};@Traverse(~1,3,1,~2,~3,1)~~R18C13Q1;   West corner~~R19C3Q5D7;    thence~~R19C6D7F800E0{4.31533e+02};431.5330~~R19C8D7E0{6.858e+01};68.58~~R19C9Q1D15; |~~R19C11Q1D15;|~~R19C12D7M3{18,12|19,6|19,8}F9248A6E2{1.218916666668445e+02|7.438077539789701e+02|1.057758039892431e+03};@Traverse(~1,3,1,~2,~3,1)~~R19C13Q1;   NW corner~~R20C3Q5D7;    thence~~R20C6D7F800E0{1.361e+02};136.10~~R20C8D7E0{2.65e+02};265.00~~R20C9Q1D15; |~~R20C11Q1D15;|~~R20C12D7M3{19,12|20,6|20,8}F9248A6E2{5.383333333315557e+01|9.001938197423283e+02|1.271693540534701e+03};@Traverse(~1,3,1,~2,~3,1)~~R20C13Q1;   North corner~~R21C3Q5D7;    thence~~R21C6D7F800E0{1.83114e+02};183.1140~~R21C8D7E0{1.8406e+02};184.06~~R21C9Q1D15; |~~R21C11Q1D15;|~~R21C12D7M3{20,12|21,6|21,8}F9248A6E2{6.805555555377765e+00|1.082956937154298e+03|1.293504696255079e+03};@Traverse(~1,3,1,~2,~3,1)~~R21C13Q1;   NE corner~~R22C3Q5D7;    thence~~R22C6D7F800E0{3.1547e+02};315.4700~~R22C8D7E0{3.05e+02};305~~R22C9Q1D15; |~~R22C11Q1D15;|~~R22C12D7M3{21,12|22,6|22,8}F9248A6E2{2.542166666664888e+02|9.999968341682671e+02|1.000004063696055e+03};@Traverse(~1,3,1,~2,~3,1)~~R22C13Q1;   SE corner~~R23C2Q41D15;----------------------------------------------------------------------------~~R24C2Q41D7;NOTE:  Column 13 contains a description of each point.~~R25C2Q41D15;----------------------------------------------------------------------------~~R26C6D14M7{16,12|17,12|18,12|19,12|20,12|21,12|22,12}F12288E14{7e+00|1e+03|1e+03|7.803326850209477e+02|8.987707175275167e+02|7.800395864749202e+02|9.995302912326606e+02|7.438077539789701e+02|1.057758039892431e+03|9.001938197423283e+02|1.271693540534701e+03|1.082956937154298e+03|1.293504696255079e+03|9.999968341682671e+02|1.000004063696055e+03};@Polygon(~1,~2,~3,~4,~5,~6,~7)~~R26C8Q9D15;   Error of Closure:~~R26C12D14M1{26,6}F7168A8E3{7.533021129057002e+04|5.151321790245291e-03|5.374225780415599e+00|1.16527e+03};@Closure(~1,0,0,1)~~R27C8Q9D15;       Area (acres):~~R27C12D14M1{26,12}E0{1.729343693539257e+00};~1/43560~~R31C7Q9D14;    FIELD SURVEY~~R33C4Q1D15;  Horiz <~~R33C6Q1D15;    Vert <~~R33C8Q1D15;  Slope Dist~~R33C10Q1D15;Point~~R33C12Q1D15;   [Northing,Easting]~~R34C2Q41D15;----------------------------------------------------------------------------~~R35C3Q1D15;|~~R35C5Q1D15; |~~R35C7Q1D15; |~~R35C9Q1D15; |~~R35C11Q1D15;|~~R36C2Q1D15;BS~~R36C3Q1D15;|~~R36C4Q17D7; (SW Corner of Lot1 - Found Pin)~~R36C9Q1D15; |~~R36C10Q1D14;<02>~~R36C11Q1D15;|~~R36C12D14M1{16,12}F9248A6E2{2.047416666664888e+02|8.102852547816008e+02|9.125737593927439e+02};@Traverse(~1,3,1,365.1530,208.89,1)~~R36C13Q1;  SW Corner of Lot 1 (Found Pin)~~R37C2Q1D15;IS~~R37C3Q1D15;|~~R37C4Q17D14; (SE Corner of Lot1 - Found Pin)~~R37C9Q1D15; |~~R37C10Q1D14;<01>~~R37C11Q1D15;|~~R37C12Q1D7;      (set above)~~R37C13Q1;  SE Corner of Lot 1 (Found Pin)~~R38C2Q1D15;FS~~R38C3Q1D15;|~~R38C4D7E0{1.551649e+02};155.1649~~R38C5Q1D15; |~~R38C6D7E0{6.3016e+00};6.3016~~R38C7Q1D15; |~~R38C8D7E0{3.6974e+02};369.74~~R38C9Q1D15; |~~R38C10Q1D14;<20>~~R38C11Q1D15;|~~R38C12D14M5{36,12|16,12|38,4|38,6|38,8}F9248A6E2{4.9461388888557e+01|1.238769433943076e+03|1.27918190199414e+03};@FieldAngle(~1,~2,3,5,~3,~4,~5,1)~~R38C13Q1;  NE Corner of LOT 2 (found pin)~~R39C2Q1D15;FS~~R39C3Q1D15;|~~R39C4D7E0{7.701439999999999e+01};77.0144~~R39C5Q1D15; |~~R39C6D7E0{0};0~~R39C7Q1D15; |~~R39C8D7E0{2.4539e+02};245.39~~R39C9Q1D15; |~~R39C10Q1D14;<22>~~R39C11Q1D15;|~~R39C12D14M5{36,12|16,12|39,4|39,6|39,8}F9248A6E2{1.277127777774459e+02|8.498940832563644e+02|1.19412487181851e+03};@FieldAngle(~1,~2,3,5,~3,~4,~5,1)~~R39C13Q1;  Control Point - Nail near edge of fence~~R40C2Q1D15;FS~~R40C3Q1D15;|~~R40C4D7E0{3.3055e+01};33.0550~~R40C5Q1D15; |~~R40C6D7E0{3.532845e+02};353.2845~~R40C7Q1D15; |~~R40C8D7E0{1.7769e+02};177.69~~R40C9Q1D15; |~~R40C10Q1D14;<23>~~R40C11Q1D15;|~~R40C12D14M5{36,12|16,12|40,4|40,6|40,8}F9248A6E2{1.716444444441125e+02|8.253334574609869e+02|1.025654083234059e+03};@FieldAngle(~1,~2,3,5,~3,~4,~5,1)~~R40C13Q1;  Control Point - Nail in center of drive~~R41C3Q1D15;|~~R41C5Q1D15; |~~R41C7Q1D15; |~~R41C9Q1D15; |~~R41C11Q1D15;|~~R42C3Q1D15;|~~R42C5Q1D15; |~~R42C7Q1D15; |~~R42C9Q1D15; |~~R42C11Q1D15;|~~R43C2Q1D15;BS~~R43C3Q1D15;|~~R43C4Q17D7; (Control Point - near fence)~~R43C9Q1D15; |~~R43C10Q1D14;<22>~~R43C11Q1D15;|~~R43C12Q1D7;    (computed above)~~R44C2Q1D15;IS~~R44C3Q1D15;|~~R44C4Q17D7; (Control Point - center of drive)~~R44C9Q1D15; |~~R44C10Q1D14;<23>~~R44C11Q1D15;|~~R44C12Q1D7;    (computed above)~~R45C2Q1D15;FS~~R45C3Q1D15;|~~R45C4D7E0{3.064023e+02};306.4023~~R45C5Q1D15; |~~R45C6D7E0{0};0~~R45C7Q1D15; |~~R45C8D7E0{8.596939999999999e+01};85.9694~~R45C9Q1D15; |~~R45C10Q1D14;<04>~~R45C11Q1D15;|~~R45C12D14M5{39,12|40,12|45,4|45,6|45,8}F9248A6E2{1.350324738616885e+02|7.645094674682945e+02|1.086409165142726e+03};@FieldAngle(~1,~2,3,5,~3,~4,~5,1)~~R45C13Q1;  West Corner of Lot 1 (Found Pin)~~R46C3Q1D15;|~~R46C5Q1D15; |~~R46C7Q1D15; |~~R46C9Q1D15; |~~R46C11Q1D15;|~~R47C2Q41D15;----------------------------------------------------------------------------~~R48C2Q41D7;NOTE:  Column 13 contains a description of each point.~~R49C2Q41D15;----------------------------------------------------------------------------~~R53C6Q17D12;              COMPUTED COORDINATES~~R54C2Q41D15;----------------------------------------------------------------------------~~R55C5Q1D15;|~~R55C6D7F18432A6E6{2.057886260471746e+02|9.000000000006401e+01|2.4343000000064e+01|6.5252999999872e+01|3.298814323096099e+01|1.371924173647831e+01|3e+01};@Triangle(3,90,24.3430,0,0,0,30)~~R55C9Q1D15; |~~R55C11Q1D15;|~~R56C5Q1D15;|~~R56C9Q1D15; |~~R56C11Q1D15;|~~R57C2Q9D7;AngAngInt~~R57C5Q1D15;|~~R57C6D7F800E0{2.31533e+02};231.5330~~R57C8D7F800E0{4.001e+02};400.1000~~R57C9Q1D15; |*~~R57C10Q1D12;{03}~~R57C11Q1D15;|~~R57C12D12M4{45,12|36,12|57,6|57,8}F9248A6E2{-1e+00|8.099922113494375e+02|1.01331438641836e+03};@AngAngInt(~1,~2,3,1,~3,~4,1)~~R57C13Q1;  PC along road of Lot 1 - 30' offset~~R58C5Q1D15;|~~R58C9Q1D15; |~~R58C11Q1D15;|~~R59C2Q9D7;DstDstInt~~R59C5Q1D15;|~~R59C6D7E0{3.05e+02};305~~R59C8D7E0{1.5e+02};150~~R59C9Q1D15; |*~~R59C10Q1D12;{06}~~R59C11Q1D15;|~~R59C12D12M4{16,12|38,12|59,6|59,8}F9248E2{-1e+00|1.089287512320038e+03|1.29163802931665e+03};@DstDstInt(~1,~2,~3,~4,1)~~R59C13Q1;  NE Corner of Lot 1 (computed)~~R60C5Q1D15;|~~R60C9Q1D15; |~~R60C11Q1D15;|~~R61C2Q9D7;<06> to {05}~~R61C5Q1D15;|~~R61C6D7F800E0{3.83114e+02};383.1140~~R61C8D7E0{1.8406e+02};184.06~~R61C9Q1D15; |~~R61C10Q1D12;{05}~~R61C11Q1D15;|~~R61C12D12M3{59,12|61,6|61,8}F9248A6E2{1.868055555553779e+02|9.065243949080728e+02|1.269826873596234e+03};@Traverse(~1,3,1,~2,~3,1)~~R61C13Q1;  North corner  (computed)~~R62C2Q9D7;AngAngInt:~~R62C5Q1D15;|~~R62C6D7F800E0{1.3723342e+02};137.23342~~R62C8D7F800E0{3.83114e+02};383.1140~~R62C9Q1D15; |*~~R62C10Q1D12;{05'}~~R62C11Q1D15;|~~R62C12D12M4{45,12|59,12|62,6|62,8}F9248A6E2{-1e+00|9.045240767703579e+02|1.269588153382921e+03};@AngAngInt(~1,~2,3,1,~3,~4,1)~~R62C13Q1;  North corner  (AngAngInt: <04> and {06})~~R63C2Q9D7;AngDstInt:~~R63C5Q1D15;|~~R63C6D7F800E0{1.83114e+02};183.1140~~R63C8D7E0{2.347e+02};234.7~~R63C9Q1D15; |~~R63C10Q1D12;{05"}~~R63C11Q1D15;|~~R63C12D12M4{59,12|45,12|63,6|63,8}F9248A6E2{-1e+00|9.103645579638369e+02|1.270285162968824e+03};@AngDstInt(~1,~2,3,1,~3,~4,1)~~R63C13Q1;  North corner  (AngDstInt: <04> and {06})~~R64C2Q41D15;----------------------------------------------------------------------------~~R65C2Q41D7;NOTE:  Column 13 contains a description of each point.~~R66C2Q41D15;----------------------------------------------------------------------------~~R70C5Q29D10;          LEGAL DESCRIPTION  (from survey)~~R70C13Q1D15;                              RADIAL STAKEOUT~~R71C2Q41D15;----------------------------------------------------------------------------~~R71C13Q9D15;  ---------------------------------------------------------------------------~~R72C3Q21D10;Beginning at the SE corner of Lot 1,~~R72C13Q1D15;      BS|  <22>  (Nail - near fence)~~R72C14Q1D15; |~~R72C15Q1;      Angle Right   distance~~R73C13Q1D15;      IS|  <23>  (Nail - center of drive)~~R73C14Q1D15; |~~R74C4Q1D14;     <01>~~R74C5Q1D10;to~~R74C6Q1D14; <02>~~R74C9Q5D10;thence~~R74C12D10M2{16,12|36,12}F7168A22E2{2.047416666665125e+02|2.088899999999999e+02|3.651530000000555e+02};@Inverse(~1,~2,3,1,1)~~R74C13Q1D15;      FS|  <01>  (SE corner - Existing Pin)~~R74C14Q1D15; |~~R74C15D15M3{39,12|40,12|16,12}F7136A54E2{3.516444444441244e+02|1.7654045731535e+02|9.003399059038711e+01};@Radial(~1,~2,~3,3,5,0)~~R75C4Q1D14;     <02>~~R75C5Q1D10;to~~R75C6Q1D12; {03}~~R75C9Q5D10;thence~~R75C12D10M2{36,12|57,12}F7168A22E2{9.016666666681489e+01|1.007410532403123e+02|4.001000000000533e+02};@Inverse(~1,~2,3,1,1)~~R75C13Q1D15;      FS|  <02>  (SW Corner - Existing Pin)~~R75C14Q1D15; |~~R75C15D15M3{39,12|40,12|36,12}F7136A54E2{2.624198807833497e+02|1.140772021217938e+02|1.79170833508266e+02};@Radial(~1,~2,~3,3,5,0)~~R76C4Q1D12;     {03}~~R76C5Q1D10;to~~R76C6Q1D14; <04>~~R76C9Q5D10;thence~~R76C12D10M2{57,12|45,12}F7168A22E2{1.218916666668266e+02|8.60902239962337e+01|4.315330000000576e+02};@Inverse(~1,~2,3,1,1)~~R76C13Q1D15;      FS|  {03}  (West Corner)~~R76C14Q1D15; |~~R76C15D15M3{39,12|40,12|57,12}F7136A54E2{2.188113814435109e+02|1.968811696832635e+01|2.225338932706079e+02};@Radial(~1,~2,~3,3,5,0)~~R77C4Q1D14;     <04>~~R77C5Q1D10;to~~R77C6Q1D12; {05}~~R77C9Q5D10;thence~~R77C12D10M2{45,12|61,12}F7168A22E2{5.225043672277187e+01|2.319704623223861e+02|1.374458427798021e+02};@Inverse(~1,~2,3,1,1)~~R77C13Q1D15;      FS|  <04>  (NW Corner - Existing Pin)~~R77C14Q1D15; |~~R77C15D143M3{39,12|40,12|45,12}F7136A54E2{1.350324738616885e+02|8.596939999999996e+01|3.06402300000064e+02};@Radial(~1,~2,~3,3,5,0)~~R78C4Q1D12;     {05}~~R78C5Q1D10;to~~R78C6Q1D12; {06}~~R78C9Q5D10;thence~~R78C12D10M2{61,12|59,12}F7168A22E2{6.805555555389695e+00|1.840600000000001e+02|1.831140000000597e+02};@Inverse(~1,~2,3,1,1)~~R78C13Q1D15;      FS|  {5}  (North Corner)~~R78C14Q1D15; |~~R78C15D15M3{39,12|40,12|61,12}F7136A54E2{7.160729747044724e+01|2.573175467720522e+02|1.005536350091087e+01};@Radial(~1,~2,~3,3,5,0)~~R79C4Q1D12;     {06}~~R79C5Q1D10;to~~R79C6Q1D14; <01>~~R79C9Q5D10;thence~~R79C12D10M2{59,12|16,12}F7168A22E2{2.529775767069202e+02|3.049999999999999e+02|3.170120723855088e+02};@Inverse(~1,~2,3,1,1)~~R79C13Q1D15;      FS|  {6}  (NE Corner)~~R79C14Q1D15; |~~R79C15D15M3{39,12|40,12|59,12}F7136A54E2{4.521946648657613e+01|3.747255030688484e+02|3.629098265510446e+01};@Radial(~1,~2,~3,3,5,0)~~R80C2Q41D15;----------------------------------------------------------------------------~~R80C13Q9D15;  ---------------------------------------------------------------------------~~R81C2Q41D7;NOTE:  The Radial Stakeout of this survey is setup starting in Column 13~~R82C2Q41D15;----------------------------------------------------------------------------~~R83C6D10M6{16,12|36,12|57,12|45,12|61,12|59,12}F12288E14{7e+00|1e+03|1e+03|8.102852547816008e+02|9.125737593927439e+02|8.099922113494375e+02|1.01331438641836e+03|7.645094674682945e+02|1.086409165142726e+03|9.065243949080728e+02|1.269826873596234e+03|1.089287512320038e+03|1.29163802931665e+03|1e+03|1e+03};@Polygon(~1,~2,~3,~4,~5,~6,~1)~~R83C8Q9D15;   Error of Closure:~~R83C12D10M1{83,6}F7168A22E3{6.96191706154315e+04|0|1.9e+02|1.116751739558932e+03};@Closure(~1,3,1,1)~~R84C8Q9D15;   Area (acres):~~R84C12D10M1{83,12}X8E0{1.59823624002368e+00};~1/43560~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~